package com.example.mapper;

import com.example.entity.Travel;
import com.example.entity.dto.TravelSearch;
import com.example.entity.vo.TravelVO;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.sql.Date;
import java.util.List;

@Mapper
public interface TravelMapper {



    List<TravelVO> findByProjectId(@Param("projectId") int projectId, @Param("time") String time);

    void addTravel(Travel travel);

    void updataTravelById(Travel travel);

    TravelVO findById(int id);

    @Delete("DELETE FROM travel WHERE id = #{id}")
    void delete(int id);

    List<TravelVO> search(TravelSearch travelSearch);
}
